package com.palnar.ilecker.constants;

public interface IDBConstants {

	
	
	/** The Db_ name. */
	public String DB_NAME 								= "ilecker";
	
	/** The Db_ path. */
	public String DB_PATH 								= "/data/data/com.palnar.ilecker/databases/";
	
	//HOTEL MASTER
			public  String TABLE_NAME_HOTEL_MASTER = "hotel_master_table";
			public  String COLUMN_NAME_HOTEL_AUTO_ID = "hotel_auto_id_column";
			public  String COLUMN_NAME_HOTEL_NAME = "hotel_name_column";
			public  String COLUMN_NAME_HOTEL_GUID = "hotel_guid_column";
			public  String COLUMN_NAME_HOTEL_MENU_VERSION = "hotel_menu_version_column";
			public  String COLUMN_NAME_HOTEL_ITEM_AVAILABILITY_VERSION = "hotel_item_availability_version_column";
			public  String COLUMN_NAME_HOTEL_IP ="hotel_ip_column";
			public  String COLUMN_NAME_HOTEL_PORT ="hotel_port_column";
	//LANGUAGE
			public  String TABLE_NAME_LANGUAGE = "language_table";
			public  String COLUMN_NAME_LANGUAGE_AUTO_ID = "language_auto_id_column";
			public  String COLUMN_NAME_LANGUAGE_ID = "language_id_column";
			public  String COLUMN_NAME_LANGUAGE_NAME = "language_name_column";
			public  String COLUMN_NAME_LANGUAGE_SHORTNAME = "language_shortname_column";
			//-------------------------hotel auto id column
	//LANGUAGE RESOURCE TABLE
			public  String TABLE_NAME_LANGUAGE_RESOURCES = "language_resources_table";
			public  String COLUMN_NAME_LANGUAGE_RESOURCES_AUTO_ID = "language_resource_auto_id_column";
			public  String COLUMN_NAME_LANGUAGE_RESOURCES_ID= "language_resources_id_column";
			//-------------------------hotel auto id column
	//LANGUAGE RESOURCE
			public  String TABLE_NAME_LANGUAGE_RESOURCES_TEXT = "language_resources_text_table";
			//-------------------------language resource auto id column
			//-------------------------language auto id column
			public  String COLUMN_NAME_LANGUAGE_RESOURCES_TEXT_VALUE = "language_resources_text_value_column";
	//SERVICE STATION TYPE 
			public  String TABLE_NAME_SERVICE_STATION_TYPE = "service_station_type_table";
			public  String COLUMN_NAME_SERVICE_STATION_TYPE_AUTO_ID ="service_station_type_auto_id_column";
			public  String COLUMN_NAME_SERVICE_STATION_TYPE_ID ="service_station_type_id_column";
			public  String COLUMN_NAME_SERVICE_STATION_TYPE_NAME ="service_station_type_name_column";	
			public  String COLUMN_NAME_SERVICE_STATION_TYPE_DELETED ="service_station_type_deleted_column";
			//-------------------------hotel auto id
	//MENU
			public  String TABLE_NAME_MENU	 = "menu_table";
			public  String COLUMN_NAME_MENU_AUTO_ID = "menu_auto_id_column";
			public  String COLUMN_NAME_MENU_ID = "menu_id_column";
			public  String COLUMN_NAME_MENU_PUBLISHED = "menu_published_column";            
			public  String COLUMN_NAME_MENU_PUBLISHER = "menu_publisher_column";
			public  String COLUMN_NAME_MENU_PUBLISHED_ON = "menu_published_on_column";
			//-------------------------hotel auto id
			public  String COLUMN_NAME_MENU_DISPLAY_NAME = "menu_display_name_column";
			public  String COLUMN_NAME_MENU_EXPIRED = "menu_expired_column";
	//SERVICE_END_POINT		
			public  String TABLE_NAME_SERVICE_END_POINT	 = "service_end_point_table";
			public  String COLUMN_NAME_SERVICE_END_POINT_AUTO_ID = "service_end_point_auto_id_column";
			public  String COLUMN_NAME_SERVICE_END_POINT_ID = "service_end_point_id_column";
		    //-------------------------hotel auto id
			public  String COLUMN_NAME_SERVICE_END_POINT_NAME = "service_end_point_name_column";
	//SERVICE STATION
			public  String TABLE_NAME_SERVICE_STATION	 = "service_station_table";
			public  String COLUMN_NAME_SERVICE_STATION_AUTO_ID = "service_station_auto_id_column";
			public  String COLUMN_NAME_SERVICE_STATION_ID = "service_station_id_column";
			 //-------------------------service end point auto id
			public  String COLUMN_NAME_SERVICE_STATION_NAME = "service_station_name_column";
			//--------------------------service station type id
						
	//GROUPS		
			public  String TABLE_NAME_GROUPS = "groups_table";
			public  String COLUMN_NAME_GROUP_AUTO_ID = "group_auto_id_column";
			public  String COLUMN_NAME_GROUP_ID = "group_id_column";
			public  String COLUMN_NAME_GROUP_NAME = "group_name_column";
			public  String COLUMN_NAME_GROUP_DESCRIPTION = "group_description_column";
			public  String COLUMN_NAME_GROUP_IMAGE = "group_image_column";
	//ITEM
			public  String TABLE_NAME_ITEM = "item_table";
			public  String COLUMN_NAME_ITEM_AUTO_ID = "item_auto_id_column";
			public  String COLUMN_NAME_ITEM_ID = "item_id_column";
			public  String COLUMN_NAME_ITEM_NAME = "item_name_column";
			public  String COLUMN_NAME_ITEM_DESCRIPTION = "item_description_column";	
			public  String COLUMN_NAME_ITEM_CODE = "item_code_column";
			public  String COLUMN_NAME_ITEM_IMAGE = "item_image_column";
			public  String COLUMN_NAME_ITEM_AVAILABILITY = "item_availability_column";
			public  String COLUMN_NAME_ITEM_PRICE = "item_price_column";
	//ITEM PRICE DETAILS
			public  String TABLE_NAME_ITEM_PRICE_DETAILS = "item_price_details_table";
			//-------------------------item auto id
			//-------------------------menu auto id
			public  String COLUMN_NAME_ITEM_PRICE_DETAILS_PRICE = "item_price_details_price_column";
	//ITEM GROUP
			public  String TABLE_NAME_ITEMGROUP = "itemgroup_table";
			public  String COLUMN_NAME_ITEMGROUP_AUTO_ID = "itemgroup_auto_id_column";		
			//-------------------------item  auto id column
			//-------------------------group auto id column
	// INGREDIENT GROUP
			public  String TABLE_NAME_INGREDIENTGROUP = "ingredientgroup_table";
			public  String COLUMN_NAME_INGREDIENTGROUP_AUTO_ID = "ingredientgroup_auto_id_column";
			public  String COLUMN_NAME_INGREDIENTGROUP_ID = "ingredientgroup_id_column";
			public  String COLUMN_NAME_INGREDIENTGROUP_NAME = "ingredientgroup_name_column";
			public  String COLUMN_NAME_INGREDIENTGROUP_DESCRIPTION = "ingredientgroup_description_column";
			//-------------------------hotel master auto id
	//INGREDIENT
			public  String TABLE_NAME_INGREDIENT = "ingredient_table";
			public  String COLUMN_NAME_INGREDIENT_AUTO_ID = "ingredient_auto_id_column";
			public  String COLUMN_NAME_INGREDIENT_ID = "ingredient_id_column";
			public  String COLUMN_NAME_INGREDIENT_NAME = "ingredient_name_column";
			public  String COLUMN_NAME_INGREDIENT_DESCRIPTION = "ingredient_description_column";
			//-------------------------ingredient group auto id column
			public  String COLUMN_NAME_INGREDIENT_IMAGE = "ingredient_image_column";		
	//ITEMINGREDIENTS
			public  String TABLE_NAME_ITEMINGREDIENTS = "itemingredients_table";
			public  String COLUMN_NAME_ITEMINGREDIENTS_AUTO_ID = "itemingredients_auto_id_column";		
			//-------------------------item auto id
			//-------------------------ingredient auto id					
	// SPECIFICATION GROUP
			public  String TABLE_NAME_SPECIFICATION_GROUP = "specification_group_table";
			public  String COLUMN_NAME_SPECIFICATION_GROUP_AUTO_ID = "specification_group_auto_id_column";
			public  String COLUMN_NAME_SPECIFICATION_GROUP_ID = "specification_group_id_column";
			public  String COLUMN_NAME_SPECIFICATION_GROUP_CODE = "specification_group_code_column";
			public  String COLUMN_NAME_SPECIFICATION_GROUP_NAME = "specification_group_name_column";
			public  String COLUMN_NAME_SPECIFICATION_GROUP_DESCRIPTION = "specification_group_description_column";
			//-------------------------hotel master auto id
	//SPECIFICATION MEMBER
			public  String TABLE_NAME_SPECIFICATION_MEMBER = "specification_member_table";
			public  String COLUMN_NAME_SPECIFICATION_MEMBER_AUTO_ID = "specification_member_auto_id_column";
			public  String COLUMN_NAME_SPECIFICATION_MEMBER_ID = "specification_member_id_column";
			public  String COLUMN_NAME_SPECIFICATION_MEMBER_CODE = "specification_member_code_column";
			//-------------------------specification group auto id
			public  String COLUMN_NAME_SPECIFICATION_MEMBER_DEFAULT = "specification_member_default_column";
			public  String COLUMN_NAME_SPECIFICATION_MEMBER_NAME = "specification_member_name_column";
			public  String COLUMN_NAME_SPECIFICATION_MEMBER_DESCRIPTION = "specification_member_description_column";
	//ITEM SPECIFICATION				
			public  String TABLE_NAME_ITEM_SPECIFICATION = "item_specification_table";
			public  String COLUMN_NAME_ITEM_SPECIFICATION_AUTO_ID = "item_specification_auto_id_column";		
			//-------------------------item auto id
			//-------------------------specification group auto id
	//MENU GROUP ASSOCIATION		
			public  String TABLE_NAME_MENU_GROUP_ASSOCIATION= "menu_group_assocication_table";
			//-------------------------menu auto id
			//-------------------------group auto id		
	//SEP MENU ASSOCIATION			
			public  String TABLE_NAME_SEP_MENU_ASSOCIATION= "sep_menu_assocication_table";
			//-------------------------sep auto id
			//-------------------------menu auto id
			
	//===============================ORDERS
	//COLORCODE		
			public  String TABLE_NAME_COLOR_CODE = "color_code_table";
			public  String COLUMN_NAME_COLOR_CODE_ID = "color_code_id_column";
			public  String COLUMN_NAME_COLOR_CODE_NAME = "color_code_name_column";
			public  String COLUMN_NAME_COLOR_CODE_COLOR = "color_code_color_column";
	//M ORDER
			public  String TABLE_NAME_M_ORDER = "m_order_table";
			public  String COLUMN_NAME_M_ORDER_ID = "m_order_id_column";
			//-------------------------service station id
			public  String COLUMN_NAME_M_ORDER_USER_ID = "m_order_user_id_column";
			//-------------------------color code id
			public  String COLUMN_NAME_M_ORDER_NOTES = "m_order_notes_column";
			public  String COLUMN_NAME_M_ORDER_PLACEMENT_TIME = "m_order_placement_time_column";
			public  String COLUMN_NAME_M_ORDER_DELIVER_AFTER = "m_order_deliver_after_column";
			public  String COLUMN_NAME_M_ORDER_ACTIVE = "m_order_active_column";
	//U ORDER
			public  String TABLE_NAME_U_ORDER = "u_order_table";
			public  String COLUMN_NAME_U_ORDER_ID = "u_order_id_column";
			//-------------------------morder id
			public  String COLUMN_NAME_U_ORDER_CREATED_TIME = "u_order_created_time_column";
	//ORDERED ITEM
			public  String TABLE_NAME_ORDERED_ITEM = "ordered_item_table";
			public  String COLUMN_NAME_ORDERED_ITEM_ID = "ordered_item_id_column";
			//-------------------------item id
	//ORDERED ITEM UPDATES
			public  String TABLE_NAME_ORDERED_ITEM_UPDATES = "ordered_item_updates_table";
			public  String COLUMN_NAME_ORDERED_ITEM_UPDATES_ID = "ordered_item_updates_id_column";
			//-------------------------ordered item id
			public  String COLUMN_NAME_ORDERED_ITEM_UPDATES_STATUS = "ordered_item_updates_status_column";
			public  String COLUMN_NAME_ORDERED_ITEM_UPDATES_UPDATED_TIME = "ordered_item_updates_updated_time_column";
			public  String COLUMN_NAME_ORDERED_ITEM_UPDATES_NOTES = "ordered_item_updates_notes_column";
	        //-------------------------u order id
	//ORDERED ITEM SPECIFICATION
			public  String TABLE_NAME_ORDERED_ITEM_SPECIFICATION = "ordered_item_specification_table";
			public  String COLUMN_NAME_ORDERED_ITEM_SPECIFICATION_ID = "ordered_item_specification_id_column";
			//-------------------------ordered item updates id.
			//-------------------------specification member id.
	
}
